package demo1.dao.Mapper;

import demo1.pojo.*;

import java.sql.ResultSet;
import java.sql.Timestamp;
import java.util.List;

public interface userMapper {
    public ResultSet checkNickName(String nickName, String userPwd) throws Exception;//检查昵称和密码能不能对的上
    public ResultSet checkPhone(String userPhone, String userPwd) throws Exception;//检查手机号和密码能不能对的上
    public ResultSet checkUserAccount(String userAccount, String userPwd) throws Exception;//检查账号和密码能不能对的上
    public ResultSet selectAll() throws Exception;//查询所有
    public ResultSet selectAllAddress() throws Exception;//查询所有地址
    public ResultSet selectAllAddressById(int userID) throws Exception;//查询所有地址
    public ResultSet selectAllById(int userID) throws Exception;//查询所有
    public ResultSet selectAllChangeUser(int userID) throws Exception;//查询申请
    public ResultSet selectAllOrder(int orderID) throws Exception;//查询申请
    public ResultSet selectAddressById(int addressID) throws Exception;//查询地址
    public ResultSet selectGouwucarById(int goodsID,int userID) throws Exception;//查询购物车里面的商品
    public ResultSet selectAllOrderForm() throws Exception;//查询所有订单里面的商品
    public ResultSet selectSignIn(int userID) throws Exception;//查询所有签到表
    public ResultSet selectChangeUser(int userID) throws Exception;//查询用户处理状态
    public ResultSet selectUserPrice(int priceID) throws Exception;//查询充值状态
    public users selectUserByNickName(String userNickName) throws Exception;//查询用户
    public users selectUserByPhone(String userPhone) throws Exception;//查询用户
    public users selectUserByAccount(String userAccount) throws Exception;//查询用户
    public List<AddressTableData> selectUserAddress(int userID) throws Exception;//查询用户地址
    public List<users> selectAllUsers() throws Exception;//查询所有用户
    public List<usersPrice> selectAllUsersPrice() throws Exception;//查询所有用户的充值订单
    public List<changeUser> selectAllChangeUsers() throws Exception;//查询所有用户
    public List<gouwucar> selectGouwucar(int userID) throws Exception;//查询用户购物车
    public List<orderForm> selectOrderForm(int userID) throws Exception;//查询用户订单
    public List<orderForm> selectAllOrderForm(int userID) throws Exception;//查询用户所有订单
    public List<orderForm> selectSuccessOrderForm(int userID) throws Exception;//查询用户支付成功订单
    public List<sign> selectAllSignNum() throws Exception;//查询所有签到人数
    public gouwucar selectGouwucarGoods(int goodsID,int userID) throws Exception;//查询用户购物车中的商品
    public orderForm selectOrderFormGoods(int orderID) throws Exception;//查询订单的商品
    public address selectUserMorenAddress(int userID) throws Exception;//查询用户地址
    public void insertUser(String userNickName,int panduan, String userPhone,String pass,String userAccount) throws Exception;//注册
    public void insertUserAddress(String userAddress,int userID) throws Exception;//新增地址
    public void insertSignIn(String userName,int userID,Timestamp time) throws Exception;//插入签到表
    public void insertChangeUserStatue(int userID) throws Exception;//插入转换表
    public void insertGouwucarGoods(int userID,int price,String goodsMessage,String goodsName,int goodsNum,int goodsID,String userAddress) throws Exception;//添加新的商品去购物车
    public void insertOrderFormGoods(int userID,int price,int totalPrice, int goodsID,String goodsName,String goodsMessage, int goodsNum,String userAddress,String userPhone) throws Exception;//添加商品到订单
    public void insertOrderFormGoodsSuccess(int userID,int price,int totalPrice, int goodsID,String goodsName,String goodsMessage, int goodsNum,String userAddress,String userPhone) throws Exception;//添加商品到订单
    public void updateGouwucarGoodsNum(int goodsNum,int userID,int goodsID) throws Exception;//更新购物车的商品数
    public void modifyUserAddress(String userAddress,int addressID) throws Exception;//修改地址
    public void updateUser(String userNickName, String userPhone, String userName,String userDo,int userID,String shopName) throws Exception;//修改用户数据
    public void updateUserPass(String userPwd,int userID) throws Exception;//修改用户数据
    public void updateUserAddress(String userAddress,int userID) throws Exception;//更新默认地址
    public void updateUserMoney(int money,int userID) throws Exception;//更新钱
    public void updateUserPanduan(int userID) throws Exception;//更新客户端变成商户端
    public void updateUserPanduan2(int userID) throws Exception;//封号
    public void updateOrderFormStatue(int orderID) throws Exception;//更新订单状态为已付款
    public void updateOrderFormStatue3(int orderID) throws Exception;//更新订单状态为申请退款中
    public void updateOrderFormStatue4(int orderID) throws Exception;//更新订单状态为退款成功
    public void updateOrderFormHandleStatue(int orderID) throws Exception;//更新订单处理状态
    public void updateChangeUserStatue(int userID) throws Exception;//更新改变客户端处理状态
    public void updateUserPriceStatue(int priceID) throws Exception;//更新充值状态
    public void insertPriceStatue(int price,users users) throws Exception;//更新钱状态
    public void deleteOrderForm(int orderID) throws Exception;//取消订单
    public void deleteOrderForm2(int orderID) throws Exception;//删除订单
    public void deleteAddress(int addressID)throws Exception;//删除地址
    public void deleteGouwucarGoods(int goodsID,int userID)throws Exception;//删除购物车里面的商品
    public void deleteGouwucarGoodsByGoodsID(int goodsID)throws Exception;//删除购物车里面的商品
    public void deleteAllGouwucarGoods(int userID)throws Exception;//清空购物车
    public void modifyOrderFormAddress(orderForm orderForm)throws Exception;//修改订单的地址
    public void modifyGouwucarGoods(float price,String goodsMessage,String goodsName,int goodsID)throws Exception;//修改订单的地址
}
